Star schema [fact 1:n dimension]...how?

Posted by Mike Gates on Server Fault See other posts from Server Fault or by Mike Gates
Published on 2010-05-06T23:17:40Z Indexed on 2010/05/06 23:29 UTC
Read the original article Hit count: 349

Filed under:

datawarehouse

|

olap

I am a newcomer to data warehouses and have what I hope is an easy question about building a star schema:

If I have a fact table where a fact record naturally has a one-to-many relationship with a single dimension, how can a star schema be modeled to support this? For example:

Fact Table: Point of Sale entry (the measurement is DollarAmount)
Dimension Table: Promotions (these are sales promotions in effect when a sale was made)

The situation is that I want a single Point Of Sale entry to be associated with multiple different Promotions. These Promotions cannot be their own dimensions as there are many many many promotions.

How do I do this?

© Server Fault or respective owner

Related posts about datawarehouse

Problem performance datawarehouse with lots of indexes

as seen on Stack Overflow - Search for 'Stack Overflow'
Our product takes tests of some 350 candidates at the same time. At the end of the test, results for each candidate are moved to a datawarehouse full of indexes on it. For each test there's some 400 records to be entered in datawarehouse. So 400 x 350 is a lot of records. If there are not much records… >>> More
Tuesday 6th Manchester SQL User Group - Chris Testa-O'Neil (Loading a datawarehouse using SSIS) and

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Chris will give a talk on Loading a datawarehouse using SQL Server Integration Services, Tony Rogerson will give a talk on Database Design: Normalisation/Denormalisation and using Surrogate Keys - practicalities/pitfalls and benefits in Microsoft SQL Server. Registration is essential which you can… >>> More
SQL 2008 Datawarehouse Collection Agent Fails with Mirrored Databases on instance

as seen on Server Fault - Search for 'Server Fault'
I have a data collection job that fails when a Database on the instance is in Recovery Mode. The database in recovery is the MIRROR partner in the database mirror. The Job that fails is as follows. collection_set_1_noncached_collect_and_upload The job consists of the following steps dcexec… >>> More
DataWarehouse - What is a good definition?

as seen on Stack Overflow - Search for 'Stack Overflow'
Could someone give me a good, practical definition of what a data warehouse is? >>> More
Handling nulls in Datawarehouse

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to ask your input on what the best practice is for handling null or empty data values when it pertains to data warehousing and SSIS/SSAS. I have several fact and dimension tables that contain null values in different rows. Specifics: 1) What is the best way to handle null date/times values… >>> More

Related posts about olap

MDX lekérdezések az Oracle OLAP-hoz

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Az Oracle OpenWord-ön, 2009. október 12-én jelentette be az Oracle, hogy elkészült a Simba Technologies MDX eszköze az Oracle OLAP eléréséhez: Oracle and Simba Technologies Introduce MDX Provider for Oracle® OLAP. Az MDX Provider for Oracle® OLAP eszközzel közvetlenül az Excel felületrol lehet elérni… >>> More
An OLAP client!

as seen on SQL Blog - Search for 'SQL Blog'
While surfing CodePlex I’ve come across a very interesting tool for all BI Developers who misses a decent OLAP client where to write, run & test MDX queries http://ranetuilibraryolap.codeplex.com/ I’ve not tested it yet, but I’ll surely do this week and I’ll post my impressions ASAP. The first… >>> More
An OLAP client!

as seen on SQL Blog - Search for 'SQL Blog'
While surfing CodePlex I’ve come across a very interesting tool for all BI Developers who misses a decent OLAP client where to write, run & test MDX queries http://ranetuilibraryolap.codeplex.com/ I’ve not tested it yet, but I’ll surely do this week and I’ll post my impressions ASAP. The first… >>> More
OWB 11gR2 – OLAP and Simba

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle Warehouse Builder was the first ETL product to provide a single integrated and complete environment for managing enterprise data warehouse solutions that also incorporate multi-dimensional schemas. The OWB 11gR2 release provides Oracle OLAP 11g deployment for multi-dimensional models (in addition… >>> More
Building dynamic OLAP data marts on-the-fly

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
At the forthcoming SQLBits conference, I will be presenting a session on how to dynamically build an OLAP data mart on-the-fly. This blog entry is intended to clarify exactly what I mean by an OLAP data mart, why you may need to build them on-the-fly and finally outline the steps needed to build… >>> More